<?php 
    
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
    
    
class mongo_db { 
    
    private $config; 
    private $connection; 
    private $db; 
    private $connection_string; 
    private $host; 
    private $port; 
    private $user; 
    private $pass; 
    private $dbname; 
    private $persist; 
    private $persist_key; 
    private $selects = array(); 
    private $wheres = array(); 
    private $sorts = array(); 
    private $limit = 999999; 
    private $offset = 0; 
    private $timeout = 200; 
    private $key = 0; 
    /**     *   --------------------------------------------------------------------------------     *  CONSTRUCTOR  *  --------------------------------------------------------------------------------     *   *  Automatically check if the Mongo PECL extension has been installed/enabled.  *  Generate the connection string and establish a connection to the MongoDB.    */
    
    public function __construct() { 
        if((IS_NOSQL != 1)){ 
            return; 
        } 
        if (!class_exists('Mongo')) { 
            //$this->error("The MongoDB PECL extension has not been installed or enabled", 500); 
        } 
        $configs =wxcity_base::load_config("cache","mongo_db"); 
        $num = count($configs['connect']); 
        $this->timeout = trim($configs['timeout']); 
        $keys = wxcity_base::load_config('double'); 
        $this->key = $keys['mongo_db']; 
        $this->config = $configs['connect'][$this->key]; 
        $status = $this->connect(); 
        if($status == false) 
        { 
            for($i = 1; $i < $num; $i++) 
            { 
                $n = $this->key + $i; 
                $key = $n >= $num ? $n - $num : $n; 
                $this->config = $configs['connect'][$key];  
                $status = $this->connect(); 
                if($status!=false) 
                { 
                    $keys['mongo_db'] = $key ; 
                    $this->key = $key; 
                    $data = "<?php\nreturn ".var_export($keys, true).";\n?>"; 
                    file_put_contents(WHTY_PATH.'configs/double.php', $data, LOCK_EX); 
                    break; 
                } 
            } 
        } 
        if($status==false) 
        { 
            die('mongoDB not connect'); 
        } 
    } 
        
    function __destruct() { 
        if((IS_NOSQL != 1)){ 
            return; 
        } 
        if($this->connection) 
        { 
            $this->connection->close(); 
        } 
    } 
        
        /**     *   --------------------------------------------------------------------------------     *  CONNECT TO MONGODB   *  --------------------------------------------------------------------------------     *   *  Establish a connection to MongoDB using the connection string generated in   *  the connection_string() method.  If 'mongo_persist_key' was set to true in the   *  config file, establish a persistent connection.  We allow for only the 'persist'     *  option to be set because we want to establish a connection immediately.  */
    private function connect() { 
        $this->connection_string(); 
        $options = array('connect'=>true,'timeout'=>$this->timeout); 
        try { 
            $this->connection = new Mongo($this->connection_string, $options); 
            $this->db = $this->connection->{$this->dbname}; 
            return($this); 
        } catch (MongoConnectionException $e) { 
            return false; 
        } 
            
    } 
    /**     *   --------------------------------------------------------------------------------     *  BUILD CONNECTION STRING  *  --------------------------------------------------------------------------------     *   *  Build the connection string from the config file.    */
    private function connection_string() { 
        $this->host = trim($this->config['hostname']); 
        $this->port = trim($this->config['port']); 
        $this->user = trim($this->config['username']); 
        $this->pass = trim($this->config['password']); 
        $this->dbname = trim($this->config['database']); 
        $this->persist = trim($this->config['autoconnect']); 
        $this->persist_key = trim($this->config['mongo_persist_key']); 
            
        $connection_string = "mongodb://"; 
        if (emptyempty($this->host)) { 
            $this->error("The Host must be set to connect to MongoDB", 500); 
        } if (emptyempty($this->dbname)) { 
            $this->error("The Database must be set to connect to MongoDB", 500); 
        } if (!emptyempty($this->user) && !emptyempty($this->pass)) { 
            $connection_string .= "{$this->user}:{$this->pass}@"; 
        } if (isset($this->port) && !emptyempty($this->port)) { 
            $connection_string .= "{$this->host}:{$this->port}"; 
        } else { 
            $connection_string .= "{$this->host}"; 
        } $this->connection_string = trim($connection_string); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  Switch_db    *  --------------------------------------------------------------------------------     *   *  Switch from default database to a different db   */
    public function switch_db($database = '') { 
        if (emptyempty($database)) { 
            $this->error("To switch MongoDB databases, a new database name must be specified", 500); 
        } $this->dbname = $database; 
        try { 
            $this->db = $this->connection->{$this->dbname}; 
            return(TRUE); 
        } catch (Exception $e) { 
            $this->error("Unable to switch Mongo Databases: {$e->getMessage()}", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  SELECT FIELDS    *  --------------------------------------------------------------------------------     *   *  Determine which fields to include OR which to exclude during the query process.  *  Currently, including and excluding at the same time is not available, so the     *  $includes array will take precedence over the $excludes array.  If you want to   *  only choose fields to exclude, leave $includes an empty array().     *   *  @usage: $this->mongo_db->select(array('foo', 'bar'))->get('foobar');    */
    public function select($includes = array(), $excludes = array()) { 
        if (!is_array($includes)) { 
            $includes = array(); 
        }  
        if (!is_array($excludes)) { 
            $excludes = array(); 
        }  
        if (!emptyempty($includes)) { 
            foreach ($includes as $col) { 
                $this->selects[$col] = 1; 
            } 
        } else { 
            foreach ($excludes as $col) { 
                $this->selects[$col] = 0; 
            } 
        } return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE PARAMETERS     *  --------------------------------------------------------------------------------     *   *  Get the documents based on these search parameters.  The $wheres array should    *  be an associative array with the field as the key and the value as the search    *  criteria.    *   *  @usage = $this->mongo_db->where(array('foo' => 'bar'))->get('foobar');   */
    public function where($wheres = array()) { 
        foreach ((array)$wheres as $wh => $val) { 
            $this->wheres[$wh] = $val; 
        } return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE_IN PARAMETERS  *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is in a given $in array().     *   *  @usage = $this->mongo_db->where_in('foo', array('bar', 'zoo', 'blah'))->get('foobar');  */
    public function where_in($field = "", $in = array()) { 
        $this->where_init($field); 
        $this->wheres[$field]['$in'] = $in; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE_NOT_IN PARAMETERS  *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is not in a given $in array().     *   *  @usage = $this->mongo_db->where_not_in('foo', array('bar', 'zoo', 'blah'))->get('foobar');  */
    public function where_not_in($field = "", $in = array()) { 
        $this->where_init($field); 
        $this->wheres[$field]['$nin'] = $in; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE GREATER THAN PARAMETERS    *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is greater than $x     *   *  @usage = $this->mongo_db->where_gt('foo', 20);     */
    public function where_gt($field = "", $x) { 
        $this->where_init($field); 
        $this->wheres[$field]['$gt'] = $x; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE GREATER THAN OR EQUAL TO PARAMETERS    *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is greater than or equal to $x     *   *  @usage = $this->mongo_db->where_gte('foo', 20);    */
    public function where_gte($field = "", $x) { 
        $this->where_init($field); 
        $this->wheres[$field]['$gte'] = $x; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE LESS THAN PARAMETERS   *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is less than $x    *   *  @usage = $this->mongo_db->where_lt('foo', 20);     */
    public function where_lt($field = "", $x) { 
        $this->where_init($field); 
        $this->wheres[$field]['$lt'] = $x; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE LESS THAN OR EQUAL TO PARAMETERS   *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is less than or equal to $x    *   *  @usage = $this->mongo_db->where_lte('foo', 20);    */
    public function where_lte($field = "", $x) { 
        $this->where_init($field); 
        $this->wheres[$field]['$lte'] = $x; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE BETWEEN PARAMETERS     *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is between $x and $y   *   *  @usage = $this->mongo_db->where_between('foo', 20, 30);    */
    public function where_between($field = "", $x, $y) { 
        $this->where_init($field); 
        $this->wheres[$field]['$gte'] = $x; 
        $this->wheres[$field]['$lte'] = $y; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE BETWEEN AND NOT EQUAL TO PARAMETERS    *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is between but not equal to $x and $y  *   *  @usage = $this->mongo_db->where_between_ne('foo', 20, 30);     */
    public function where_between_ne($field = "", $x, $y) { 
        $this->where_init($field); 
        $this->wheres[$field]['$gt'] = $x; 
        $this->wheres[$field]['$lt'] = $y; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE NOT EQUAL TO PARAMETERS    *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is not equal to $x     *   *  @usage = $this->mongo_db->where_between('foo', 20, 30);    */
    public function where_ne($field = "", $x) { 
        $this->where_init($field); 
        $this->wheres[$field]['$ne'] = $x; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE OR     *  --------------------------------------------------------------------------------     *   *  Get the documents where the value of a $field is in one or more values   *   *  @usage = $this->mongo_db->where_or('foo', array( 'foo', 'bar', 'blegh' );  */
    public function where_or($field = "", $values) { 
        $this->where_init($field); 
        $this->wheres[$field]['$or'] = $values; 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE AND    *  --------------------------------------------------------------------------------     *   *  Get the documents where the elements match the specified values  *   *  @usage = $this->mongo_db->where_and( array ( 'foo' => 1, 'b' => 'someexample' );     */
    public function where_and($elements_values = array()) { 
        foreach ((array)$elements_values as $element => $val) { 
            $this->wheres[$element] = $val; 
        } return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE MOD    *  --------------------------------------------------------------------------------     *   *  Get the documents where $field % $mod = $result  *   *  @usage = $this->mongo_db->where_mod( 'foo', 10, 1 );   */
    public function where_mod($field, $num, $result) { 
        $this->where_init($field); 
        $this->wheres[$field]['$mod'] = array($num, $result); 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------    *   Where size  *   --------------------------------------------------------------------------------    *   *   Get the documents where the size of a field is in a given $size int *   *   @usage : $this->mongo_db->where_size('foo', 1)->get('foobar');  */
    public function where_size($field = "", $size = "") { 
        $this->_where_init($field); 
        $this->wheres[$field]['$size'] = $size; 
        return ($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  LIKE PARAMETERS  *  --------------------------------------------------------------------------------     *       *  Get the documents where the (string) value of a $field is like a value. The defaults     *  allow for a case-insensitive search.     *   *  @param $flags    *  Allows for the typical regular expression flags:     *      i = case insensitive     *      m = multiline    *      x = can contain comments     *      l = locale   *      s = dotall, "." matches everything, including newlines   *      u = match unicode    *   *  @param $enable_start_wildcard    *  If set to anything other than TRUE, a starting line character "^" will be prepended  *  to the search value, representing only searching for a value at the start of     *  a new line.  *   *  @param $enable_end_wildcard  *  If set to anything other than TRUE, an ending line character "$" will be appended    *  to the search value, representing only searching for a value at the end of   *  a line.  *   *  @usage = $this->mongo_db->like('foo', 'bar', 'im', FALSE, TRUE);   */
    public function like($field = "", $value = "", $flags = "i", $enable_start_wildcard = TRUE, $enable_end_wildcard = TRUE) { 
        $field = (string) trim($field); 
        $this->where_init($field); 
        $value = (string) trim($value); 
        $value = quotemeta($value); 
        if ($enable_start_wildcard !== TRUE) { 
            $value = "^" . $value; 
        } if ($enable_end_wildcard !== TRUE) { 
            $value .= "$"; 
        } $regex = "/$value/$flags"; 
        $this->wheres[$field] = new MongoRegex($regex); 
        return($this); 
    } 
    
    public function wheres($where){ 
        $this->wheres = $where; 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  ORDER BY PARAMETERS  *  --------------------------------------------------------------------------------     *   *  Sort the documents based on the parameters passed. To set values to descending order,    *  you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be   *  set to 1 (ASC).  *   *  @usage = $this->mongo_db->where_between('foo', 20, 30);    */
    public function order_by($fields = array()) { 
        if (!is_array($fields) || !count($fields)) return ; 
        foreach ($fields as $col => $val) { 
            if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') { 
                $this->sorts[$col] = -1; 
            } else { 
                $this->sorts[$col] = 1; 
            } 
        } return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  LIMIT DOCUMENTS  *  --------------------------------------------------------------------------------     *   *  Limit the result set to $x number of documents   *   *  @usage = $this->mongo_db->limit($x);   */
    public function limit($x = 99999) { 
        if ($x !== NULL && is_numeric($x) && $x >= 1) { 
            $this->limit = (int) $x; 
        } return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  OFFSET DOCUMENTS     *  --------------------------------------------------------------------------------     *   *  Offset the result set to skip $x number of documents     *   *  @usage = $this->mongo_db->offset($x);  */
    public function offset($x = 0) { 
        if ($x !== NULL && is_numeric($x) && $x >= 1) { 
            $this->offset = (int) $x; 
        } return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  GET_WHERE    *  --------------------------------------------------------------------------------     *   *  Get the documents based upon the passed parameters   *   *  @usage = $this->mongo_db->get_where('foo', array('bar' => 'something'));    */
    public function get_where($collection = "", $where = array(), $limit = 99999, $orderby=array()) { 
        if (is_array($orderby) || !emptyempty($orderby)) { 
            $order_by = $this->order_by($order_by); 
        } 
        return($this->where($where)->limit($limit)->get($collection)); 
    } 
    public function selectA($collection = "", $limit = 99999, $orderby=array()) { 
        if(intval($limit)<1){ 
            $limit = 999999; 
        } 
        $order_by = $this->order_by($orderby); 
        $re = $this->limit($limit)->get($collection); 
        $this->clear(); 
        return (array)$re; 
    } 
    
    public function listinfo($collection = "", $orderby=array(), $page=1, $pagesize=12) { 
        $page = max(intval($page), 1); 
        $offset = $pagesize * ($page - 1); 
        $pagesizes = $offset + $pagesize; 
        $this->offset($offset); 
        $order_by = $this->order_by($orderby); 
        $re = $this->limit($pagesize)->get($collection); 
        $this->limit(999999); 
        $count = $this->count($collection); 
        $this->pages = pages($count, $page, $pagesize); 
        return (array)$re; 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  GET  *  --------------------------------------------------------------------------------     *   *  Get the documents based upon the passed parameters   *   *  @usage = $this->mongo_db->get('foo', array('bar' => 'something'));  */
    public function get($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500); 
        } $results = array(); 
        $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts); 
        $returns = array(); 
        foreach ($documents as $doc): $returns[] = $doc; 
        endforeach; 
        return($returns); 
    } 
    
    public function getMy($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("In order to retreive documents from MongoDB, a collection name must be passed", 500); 
        } $results = array(); 
        $documents = $this->db->{$collection}->find($this->wheres, $this->selects)->limit((int) $this->limit)->skip((int) $this->offset)->sort($this->sorts); 
        $returns = array(); 
        foreach ($documents as $doc): $returns[] = $doc; 
        endforeach; 
        $this -> clear(); 
        return($returns); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  COUNT    *  --------------------------------------------------------------------------------     *   *  Count the documents based upon the passed parameters     *   *  @usage = $this->mongo_db->get('foo');  */
    public function count($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("In order to retreive a count of documents from MongoDB, a collection name must be passed", 500); 
        } $count = $this->db->{$collection}->find($this->wheres)->limit((int) $this->limit)->skip((int) $this->offset)->count(); 
        $this->clear(); 
        return($count); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  INSERT   *  --------------------------------------------------------------------------------     *   *  Insert a new document into the passed collection     *   *  @usage = $this->mongo_db->insert('foo', $data = array());  */
    public function insert($collection = "", $data = array(), $name='ID') { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection selected to insert into", 500); 
        } if (count($data) == 0 || !is_array($data)) { 
            $this->error("Nothing to insert into Mongo collection or insert is not an array", 500); 
        } try { 
        /**
            wxcity_base::load_sys_class('whtysqs','',0); 
            $mongoseq_class = new whtysqs('creaseidsqs');
            $re = $mongoseq_class->query("?name=" . $collection . "&opt=put&data=1");
        **/
            $re = put_sqs('list_mongo_creaseidsqs','1'); 
            if(is_numeric($re)){ 
                $re++; 
                $data[$name] = intval($re); 
            }else{ 
                $data[$name] = intval(time()); 
                //die('mongosqs error'); 
            } 
            $this->db->{$collection}->insert($data, array('fsync' => TRUE));  
            $this->clear(); 
            return $data[$name]; 
        } catch (MongoCursorException $e) { 
            $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500); 
        } 
    } 
    
    public function insertWithId($collection = "", $data = array()) { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection selected to insert into", 500); 
        } if (count($data) == 0 || !is_array($data)) { 
            $this->error("Nothing to insert into Mongo collection or insert is not an array", 500); 
        } try { 
            $this->db->{$collection}->insert($data, array('fsync' => TRUE));  
            $this->clear(); 
            return 1; 
        } catch (MongoCursorException $e) { 
            $this->error("Insert of data into MongoDB failed: {$e->getMessage()}", 500); 
        } 
    } 
    /**     *   --------------------------------------------------------------------------------     *  UPDATE   *  --------------------------------------------------------------------------------     *   *  Update a document into the passed collection     *   *  @usage = $this->mongo_db->update('foo', $data = array());  */
    public function update($collection = "", $data = array()) { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection selected to update", 500); 
        } if (count($data) == 0 || !is_array($data)) { 
            $this->error("Nothing to update in Mongo collection or update is not an array", 500); 
        } try { 
            $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => FALSE)); 
            $this->clear(); 
            return(TRUE); 
        } catch (MongoCursorException $e) { 
            $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  UPDATE_ALL   *  --------------------------------------------------------------------------------     *   *  Insert a new document into the passed collection     *   *  @usage = $this->mongo_db->update_all('foo', $data = array());  */
    public function update_all($collection = "", $data = array()) { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection selected to update", 500); 
        } if (count($data) == 0 || !is_array($data)) { 
            $this->error("Nothing to update in Mongo collection or update is not an array", 500); 
        } try { 
            $this->db->{$collection}->update($this->wheres, array('$set' => $data), array('fsync' => TRUE, 'multiple' => TRUE)); 
            return(TRUE); 
        } catch (MongoCursorException $e) { 
            $this->error("Update of data into MongoDB failed: {$e->getMessage()}", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  DELETE   *  --------------------------------------------------------------------------------     *   *  delete document from the passed collection based upon certain criteria   *   *  @usage = $this->mongo_db->delete('foo', $data = array());  */
    public function delete($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection selected to delete from", 500); 
        } try { 
            $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => TRUE)); 
            $this->clear(); 
            return(TRUE); 
        } catch (MongoCursorException $e) { 
            $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  DELETE_ALL   *  --------------------------------------------------------------------------------     *   *  Delete all documents from the passed collection based upon certain criteria  *   *  @usage = $this->mongo_db->delete_all('foo', $data = array());  */
    public function delete_all($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection selected to delete from", 500); 
        } try { 
            $this->db->{$collection}->remove($this->wheres, array('fsync' => TRUE, 'justOne' => FALSE)); 
            return(TRUE); 
        } catch (MongoCursorException $e) { 
            $this->error("Delete of data into MongoDB failed: {$e->getMessage()}", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  ADD_INDEX    *  --------------------------------------------------------------------------------     *   *  Ensure an index of the keys in a collection with optional parameters. To set values to descending order,     *  you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be   *  set to 1 (ASC).  *   *  @usage = $this->mongo_db->add_index($collection, array('first_name' => 'ASC', 'last_name' => -1), array('unique' => TRUE));   */
    public function add_index($collection = "", $keys = array(), $options = array()) { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection specified to add index to", 500); 
        } if (emptyempty($keys) || !is_array($keys)) { 
            $this->error("Index could not be created to MongoDB Collection because no keys were specified", 500); 
        } foreach ($keys as $col => $val) { 
            if ($val == -1 || $val === FALSE || strtolower($val) == 'desc') { 
                $keys[$col] = -1; 
            } else { 
                $keys[$col] = 1; 
            } 
        } if ($this->db->{$collection}->ensureIndex($keys, $options) == TRUE) { 
            $this->clear(); 
            return($this); 
        } else { 
            $this->error("An error occured when trying to add an index to MongoDB Collection", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  REMOVE_INDEX     *  --------------------------------------------------------------------------------     *   *  Remove an index of the keys in a collection. To set values to descending order,  *  you must pass values of either -1, FALSE, 'desc', or 'DESC', else they will be   *  set to 1 (ASC).  *   *  @usage = $this->mongo_db->remove_index($collection, array('first_name' => 'ASC', 'last_name' => -1));    */
    public function remove_index($collection = "", $keys = array()) { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection specified to remove index from", 500); 
        } if (emptyempty($keys) || !is_array($keys)) { 
            $this->error("Index could not be removed from MongoDB Collection because no keys were specified", 500); 
        } if ($this->db->{$collection}->deleteIndex($keys, $options) == TRUE) { 
            $this->clear(); 
            return($this); 
        } else { 
            $this->error("An error occured when trying to remove an index from MongoDB Collection", 500); 
        } 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  REMOVE_ALL_INDEXES   *  --------------------------------------------------------------------------------     *   *  Remove all indexes from a collection.    *   *  @usage = $this->mongo_db->remove_all_index($collection);   */
    public function remove_all_indexes($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection specified to remove all indexes from", 500); 
        } $this->db->{$collection}->deleteIndexes(); 
        $this->clear(); 
        return($this); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  LIST_INDEXES     *  --------------------------------------------------------------------------------     *   *  Lists all indexes in a collection.   *   *  @usage = $this->mongo_db->list_indexes($collection);   */
    public function list_indexes($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection specified to remove all indexes from", 500); 
        } return($this->db->{$collection}->getIndexInfo()); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  DROP COLLECTION  *  --------------------------------------------------------------------------------     *   *  Removes the specified collection from the database.  Be careful because this     *  can have some very large issues in production!   */
    public function drop_collection($collection = "") { 
        if (emptyempty($collection)) { 
            $this->error("No Mongo collection specified to drop from database", 500); 
        } $this->db->{$collection}->drop(); 
        return TRUE; 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  CLEAR    *  --------------------------------------------------------------------------------     *   *  Resets the class variables to default settings   */
    private function clear() { 
        $this->selects = array(); 
        $this->wheres = array(); 
        $this->limit = NULL; 
        $this->offset = NULL; 
        $this->sorts = array(); 
    } 
    
    /**     *   --------------------------------------------------------------------------------     *  WHERE INITIALIZER    *  --------------------------------------------------------------------------------     *   *  Prepares parameters for insertion in $wheres array().    */
    private function where_init($param) { 
        if (!isset($this->wheres[$param])) { 
            $this->wheres[$param] = array(); 
        } 
    } 
    
    public function error($str, $t) { 
        echo $str; 
        exit; 
    } 
    
} 
       
?>  

使用范例
?
1
2
3
4
$table_name=trim(strtolower($this->table_name)); 
$this->mongo_db->where($where); 
$order=!emptyempty($order)?array('AID'=>'DESC'):array('AID'=>'ASC');//升序降序 
$infos=$this->mongo_db->listinfo($table_name,$order,$page,$pagesize);